package com.example.demo.oracleDao;

import com.example.demo.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

//@Mapper
@Repository
public interface OrcalDao {

    List<Map<String, Object>> selectTestOracle(Map<String, Object> params);

    //查LD_ALARMITEMS数据
    List<Alarmitems> OraAlarmitems();

    //查视图2
    List<Basicinfo> OraBasicinfo();

    //查视图3
    List<Checkcar> OraCheckcar();

    //查视图4
    List<Checksize> OraChecksize();

    //查视图5
    List<Checkwheelscar> OraCheckwheelscar();

    //查视图6
    List<Overdemarcationrecord> OraOverdemarcationrecord();

    //查视图7
    List<Jczb> OraJczb();

    //以下是各个表总行数
    //视图1
    int OraAlarmitemsCounts();
    //视图2
    int OraBasicinfoCounts();
    //视图3
    int OraCheckcarCounts();
    //视图4
    int OraChecksizeCounts();
    //视图5
    int OraCheckwheelscarCounts();
    //视图6
    int OraOverdemarcationrecordCounts();
    //视图7
    int OraJczbCounts();

    //以下是各个表的分页数据
    //查视图1 LD_ALARMITEMS数据
    List<Alarmitems> OraAlarmitemsPage(Map<String, Object> params);

    //查视图2
    List<Basicinfo> OraBasicinfoPage(Map<String, Object> params);

    //查视图3
    List<Checkcar> OraCheckcarPage(Map<String, Object> params);

    //查视图4
    List<Checksize> OraChecksizePage(Map<String, Object> params);

    //查视图5
    List<Checkwheelscar> OraCheckwheelscarPage(Map<String, Object> params);

    //查视图6
    List<Overdemarcationrecord> OraOverdemarcationrecordPage(Map<String, Object> params);

    //查视图7
    List<Jczb> OraJczbPage(Map<String, Object> params);



    //以下是根据最大时间最小时间来查增量
    //查视图1
    List<Alarmitems> OraAlarmitemsPageMax(Map<String, Object> params);
    //查视图2
    List<Basicinfo> OraBasicinfoPageMax(Map<String, Object> params);
    //查视图3
    List<Checkcar> OraCheckcarPageMax(Map<String, Object> params);
    //查视图4
    List<Checksize> OraChecksizePageMax(Map<String, Object> params);
    //查视图5
    List<Checkwheelscar> OraCheckwheelscarPageMax(Map<String, Object> params);
    //查视图6
    List<Overdemarcationrecord> OraOverdemarcationrecordPageMax(Map<String, Object> params);
    //查视图7
    List<Jczb> OraJczbPageMax(Map<String, Object> params);




}
